Re: Looking for postgres equivalent of mysqlimport - Mailing list pgsql-novice

At 9:37 AM -0400 9/17/04, Sean Davis wrote:
>Marc,
>
>Thanks.  That is what I had thought.  Another detail--I have fields
>(including some dates) that include "" (empty fields).  What is the
>best way to deal with those?  Should I just convert them to NULL
>(assuming that was the actual meaning) and then use that as the NULL
>string in the copy command?

Sean,

I think you could try that.  You may leave them empty as well (after
stripping '"') and use that for NULL with the COPY command.

Marc